Tabela BudgetStructure

Definicja tabeli BudgetStructure

Name

BudgetStructure

Code

BudgetStructure

Comment

Struktury budzetowe


Lista kolumn tabeli BudgetStructure

Name

Code

BudgetStructureID

BudgetStructureID

Name

Name

Description

Description

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna BudgetStructureID tabeli BudgetStructure

Definicja kolumny BudgetStructureID tabeli BudgetStructure

Name

BudgetStructureID

Code

BudgetStructureID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID struktury


Kolumna Name tabeli BudgetStructure

Definicja kolumny Name tabeli BudgetStructure

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Nazwa


Kolumna Description tabeli BudgetStructure

Definicja kolumny Description tabeli BudgetStructure

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna StartDT tabeli BudgetStructure

Definicja kolumny StartDT tabeli BudgetStructure

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku waznosci struktury


Kolumna StopDT tabeli BudgetStructure

Definicja kolumny StopDT tabeli BudgetStructure

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca waznosci struktury


Kolumna Active tabeli BudgetStructure

Definicja kolumny Active tabeli BudgetStructure

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Aktywny


Lista kluczy tabeli BudgetStructure

Name

Code

Primary

PK_BUDGETSTRUCTURE

PK_BUDGETSTRUCTURE

X


Klucz PK_BUDGETSTRUCTURE tabeli BudgetStructure

Definicja klucza PK_BUDGETSTRUCTURE tabeli BudgetStructure

Name

PK_BUDGETSTRUCTURE

Code

PK_BUDGETSTRUCTURE

Primary

Yes

Comment